<?php

/**
 * This is the model class for table "religion".
 *
 * The followings are the available columns in table 'religion':
 * @property integer $id
 * @property string $name_en
 * @property string $name_th
 * @property integer $active
 * @property integer $delmark
 * @property string $created_date
 * @property string $updated_date
 *
 * The followings are the available model relations:
 * @property User[] $users
 */
class Religion extends CActiveRecord
{
    /**
     * Returns the static model of the specified AR class.
     * @param string $className active record class name.
     * @return Religion the static model class
     */
    public static function model($className=__CLASS__)
    {
        return parent::model($className);
    }

    /**
     * @return string the associated database table name
     */
    public function tableName()
    {
        return 'religion';
    }

    /**
     * @return array validation rules for model attributes.
     */
    public function rules()
    {
        // NOTE: you should only define rules for those attributes that
        // will receive user inputs.
        return array(
            array('name_en', 'required'),
            array('active, delmark', 'numerical', 'integerOnly'=>true),
            array('name_en, name_th', 'length', 'max'=>45),
            array('created_date, updated_date', 'safe'),
            // The following rule is used by search().
            // Please remove those attributes that should not be searched.
            array('id, name_en, name_th, active, delmark, created_date, updated_date', 'safe', 'on'=>'search'),
        );
    }

    /**
     * @return array relational rules.
     */
    public function relations()
    {
        // NOTE: you may need to adjust the relation name and the related
        // class name for the relations automatically generated below.
        return array(
            'users' => array(self::HAS_MANY, 'User', 'religion_id'),
        );
    }

    /**
     * @return array customized attribute labels (name=>label)
     */
    public function attributeLabels()
    {
        return array(
            'id' => 'ID',
            'name_en' => 'Name En',
            'name_th' => 'Name Th',
            'active' => 'Active',
            'delmark' => 'Delmark',
            'created_date' => 'Created Date',
            'updated_date' => 'Updated Date',
        );
    }

    /**
     * Retrieves a list of models based on the current search/filter conditions.
     * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
     */
    public function search()
    {
        // Warning: Please modify the following code to remove attributes that
        // should not be searched.

        $criteria=new CDbCriteria;

		$criteria->compare('id',$this->id);
		$criteria->compare('name_en',$this->name_en,true);
		$criteria->compare('name_th',$this->name_th,true);
		$criteria->compare('active',$this->active);
		$criteria->compare('delmark',$this->delmark);
		$criteria->compare('created_date',$this->created_date,true);
		$criteria->compare('updated_date',$this->updated_date,true);

        return new CActiveDataProvider($this, array(
            'criteria'=>$criteria,
        ));
    }

    /**
     * before save
     */
    public function beforeSave() {
        if ($this->isNewRecord)
            $this->created_date = new CDbExpression('NOW()');
        else
            $this->updated_date = new CDbExpression('NOW()');
    
        return parent::beforeSave();
    }

    /**
     * get Delmark off 
     * @return array()
     */
    public function getAll()
    {
        return $this->findAll('delmark=:delmark', array(':delmark' => false));
    }

    /**
     * get Delmark off and Active on
     * @return array()
     */
    public function getAllActive()
    {
        return $this->findAll('delmark=:delmark AND active=:active', array(
                   ':delmark' => false,
                   ':active'  => true,
               ));
    }

    /**
     * virtual field : active
     * @return boolean
     */
    public function getActiveFlag()
    {
        return $this->active==1 ? 'true' : 'false';
    }

    /**
     * virtual field : Name
     * @return string
     */
    public function getName()
    {
        $ret = $this->name_en;
    
        if (isset(Yii::app()->language)) {
            switch (Yii::app()->language) {
                case "th":
                    $data = $this->name_th;
                    $ret = (isset($data) && ($data!=''))  ? $data : $ret;
                break;
                default:
                    $ret = $this->name_en;
            }
        }
    
        return $ret;
    }


}